
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_SinhVien_GetTotalSinhVienByTen]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[sp_SinhVien_GetTotalSinhVienByTen]
GO
create procedure sp_SinhVien_GetTotalSinhVienByTen
	@TenSV nvarchar(100),
	@DiaChi nvarchar(100)
as
begin			
		SELECT COUNT(MaSV) As Total   
				FROM SinhVien
				WHERE SinhVien.Ten_SV like @TenSV and SinhVien.Dia_Chi like @DiaChi
end



